Previous topicNext topic
 Link Technologies - LinkSOFT Documentation 
Help > Link Web Applications Portal > Company Administration > Processes >
System (SYS)

List of processes and its functionalities:

Process Code

Description

Default Frequency

FMISAP FMISSQLAPI - Perform FMIS integration for Accounts Payable.  Every Minute
FMISAR FMISSQLAPI - Perform FMIS integration for Accounts Receivable Process.  Every Minute
FMIS30 FMISSQLAPI - Perform FMIS integration for Accounts Receivable Validate.  Every Minute
FMISGL FMISSQLAPI - Perform FMIS integration for General Ledger.  Every Minute
FMIS10 FMISSQLAPI - Perform all master file import from FMIS. This includes Accounts Receivable, Accounts Payable, Inventory and General Ledger.  Every Minute
LBO001

System Health Check for LinkSOFT Application

Process Rules

Rule Code

Description

Value caption

Default Value

LBO001-REC01

Show applicants that have created a vacancy application but not submitted in [N] days

N days. Zero will disable this rule

5

LBO001-HRM07

ATO Single Touch has not completed in [N] days

N days. Zero will disable this rule

15

LBO001-HRM08

Exit questions have not been completed in [N] days

N days. Zero will disable this rule

5

LBO001-HRM06

Leave applications have not been actioned in [N] days

N days. Zero will disable this rule

15

LBO001-HRM09

Performance Appraisal not completed in [N] days

N days. Zero will disable this rule

10

LBO001-HRM02

Show "Pay Teams" with no "Role" access

Enabled (Y/N)

Y

LBO001-HRM01

Show employees that are active but have missing "Pay Rate" and "Position"

Enabled (Y/N)

Y

LBO001-HRM03

Show employees that are active but have no leave allocations

Enabled (Y/N)

Y

LBO001-HRM04

Show employees that are active but have no standard pay

Enabled (Y/N)

Y

LBO001-HRM10

Show employees with "start date" greater than "next pay date"

Enabled (Y/N)

Y

LBO001-HRM12

Show employees with no "Employer Super Split" entries

Enabled (Y/N)

Y

LBO001-HRM11

Show employees with no "Standard Pay" entries

Enabled (Y/N)

Y

LBO001-HRM05

Verify Pay Calendar is closed after [N] days

N days. Zero will disable this rule

15

LBO001-POS12

Purchase Orders not actioned in [N] days

N days. Zero will disable this rule

5

LBO001-POS11

Purchase Request not actioned in [N] days

N days. Zero will disable this rule

5

LBO001-POS07

Show failures in GL Valuation Process

Enabled (Y/N)

Y

LBO001-POS09

Show failures in replication compare data process

Enabled (Y/N)

Y

LBO001-POS08

Show Replication queue failures not resolved in [N] days

N days. Zero will disable this rule

1

LBO001-POS04

Show replication queue summary information

Enabled (Y/N)

Y

LBO001-POS10

Verify "Defaults" are setup for inventory

Enabled (Y/N)

Y

LBO001-POS06

Verify all products have a price setup

Enabled (Y/N)

Y

LBO001-POS03

Verify customer master file "Balance" matches with customer transactions

Enabled (Y/N)

Y

LBO001-POS14

Verify inventory master file "In Stock" is not negative when "Allow Negative" flag is unticked

Enabled (Y/N)

Y

LBO001-POS13

Verify inventory master file "In Stock" matches with "Lot Bin/Product Matrix"

Enabled (Y/N)

Y

LBO001-POS01

Verify inventory master file "In Stock" matches with inventory transactions

Enabled (Y/N)

Y

LBO001-POS05

Verify POS Invoice summary values matches with invoice lines for past [N] days

N days. Zero will disable this rule

Y

LBO001-POS02

Verify POSCASH customer balance is zero as this is a "cash only" customer

Enabled (Y/N)

Y

LBO001-FMS03

Asset depreciation for a previous month not completed in [N] days

N days. Zero will disable this rule

5

 End of Day

SYS001

Server process used to prepare alerts, complex computations and system maintenance functions. Used by all modules.
Recommend: Active, Every Second

 Every Second
SYS003

Database backup. Removes old backups based on retention days.
Recommend: Active, End of Day.

Process Rules
 Rule Code  Description  Value Caption  Default Value
 System.DatabaseBackup.RetentionDays  System database backup retention days  Days  7
 System.DatabaseBackup.Path  System database backup path  Full Folder Path  D:\MSSQL\Backup
 System.DatabaseBackup.This  Backup "This" database  Enabled (Y/N)  Y
 System.DatabaseBackup.Other  Backup the other database names (comma separated)  Database Names (Comma Separated)  
 System.DatabaseBackup.FTPUpload  FTP Upload to Link Technologies Secure Cloud Backup facility. The scheduler account must have access to the backup path.  FTP Upload  N

 End of Day
 SYS004

Database cleanup (Purge: Replication History, system logs, mail logs, Order Tax Integration (TMS,VMS,FRCS,SDC)) based on [days to keep] configuration.
Recommend: Active, run once per month after hours.

Process Rules
 Rule Code Description Value Caption  Default Value
SYS004.DatabaseBackup.DaysToKeep Remove deleted log entries from "Database Backup" and "FTP Backups". Menu: "Global Administration -> Database Backup". The number in this field defines the number of days to keep. Days To Keep 30
 SYS004.MailLog.DaysToKeep Remove entries from Email logs including attachments. The number in this field defines the number of days to keep. Days To Keep  30
 SYS004.EventLog.DaysToKeep Remove entries from Event Log. The number in this field defines the number of days to keep. Days To Keep  30
SYS004.EventLogWithSourceReference.DaysToKeep Remove entries from Event Log that is linked to other forms. E.g user audit logs. The number in this field defines the number of days to keep. Days To Keep 365
SYS004.ExternalLinkAction.DaysToKeep Remove entries from tables that hold External Link Action. The number in this field defines the number of days to keep. Days To Keep 30
 SYS004.OrderBIBuildItems.DaysToKeep Remove entries from tables that hold Order Build Items with status = "Delivered" (Processing View). The number in this field defines the number of days to keep. Days To Keep  30
 SYS004.Replication.DaysToKeep Remove entries from tables that hold Replication history (Analysis & Replication History Data). The number in this field defines the number of days to keep. Days To Keep  30
SYS004.ProcessMaintenanceLog.DaysToKeep Remove log entries for processes. Menu: "Global Administration -> Process Setup -> Process Detail -> Log". The number in this field defines the number of days to keep. Days To Keep 30
 SYS004.OrderTaxIntegration.DaysToKeep Remove Tax Integration QR codes and Verification URL from Tax Integration tables. Entries in this table are not removed as these are required for Audit, Reprint and Returns. The number in this field defines the number of days to keep. Days To Keep  30

 End of Day
 SYS005

Email alert to send all system log entries that have not been sent previously.
Recommend: Active, run daily.

Email is sent to the address defined in this process.

 End of Day
 SYS007

System Health Check. Recommend: Active, run daily.

Process Rules

Rule Code

Description

Value caption

Default Value

SYS007.SYS04

Backups have not been performed in more than [N] days

[N] days. Zero will disable this rule

1

SYS007.SYS20

Company not setup

Enabled (Y/N)

Y

SYS007.SYS21

Currency not setup

Enabled (Y/N)

Y

SYS007.SYS02

Database storage disk space is less than [N]% free

[N] percent free. Zero will disable this rule

20

SYS007.SYS23

Licence will expire in [N] days

[N] days. Zero will disable this rule

30

SYS007.SYS17

Organisation not setup

Enabled (Y/N)

Y

SYS007.SYS05

Perform database consistency check and display errors

Enabled (Y/N)

Y

SYS007.SYS06

Show database backup errors

Enabled (Y/N)

Y

SYS007.SYS01

Show database size information

Enabled (Y/N)

Y

SYS007.SYS07

Show email queue failures

Enabled (Y/N)

Y

SYS007.SYS12

Show errors in AP Invoice not resolved in [N] days

N days. Zero will disable this rule

1

SYS007.SYS15

Show errors in AR Adjustment not resolved in [N] days

N days. Zero will disable this rule

1

SYS007.SYS16

Show errors in AR Receipt not resolved in [N] days

N days. Zero will disable this rule

1

SYS007.SYS14

Show errors in AR Sales Order not resolved in [N] days

N days. Zero will disable this rule

1

SYS007.SYS11

Show errors in GL Journal not resolved in [N] days

N days. Zero will disable this rule

1

SYS007.SYS18

Show errors in processes

Enabled (Y/N)

Y

SYS007.SYS19

Show important processes that should be enabled

Enabled (Y/N)

Y

SYS007.SYS24

Show indexes fragmented over [N]%

[N] percent. Zero will disable this rule

10

SYS007.SYS03

Show last backup information

Enabled (Y/N)

Y

SYS007.SYS08

Show number of emails in queue when exceeding [N] records

N records. Zero will disable this rule

100

SYS007.SYS10

Show number of report emails in queue when exceeding [N] records

N records. Zero will disable this rule

100

SYS007.SYS09

Show report email queue failures

Enabled (Y/N)

Y

SYS007.SYS22

Show users with failed password attempts more than [N]

[N] attempts. Zero will disable this rule

1

LBO001-HEL01

Open calls with no updates in [N] days

N days. Zero will disable this rule

5

LBO001-HEL03

Organisation has a score below [N]

N score. Zero will disable this rule

5

LBO001-HEL02

Organisation has calls, however, there are no surveys sent in the last [N] days

N days. Zero will disable this rule

30

 End of Day
 SYS008 Rebuild database indexes.
Recommend: Active, run daily after hours.
 End of Day
 SYS009 Process to validate "Report Email Log" data exists. This process validates the "Queued" records and updates the status to "No Data" or "Ready to Send".
Recommend: Active, run every minute.
 Every Minute
 SYS010

Enforce Password Expiration. This process forces users to change their password on login after [N] days has passed after the last password change.

Process Rules
 Rule Code  Description  Value Caption  Default Value
 SYS010.ExpiryDays  Password Expiry Days  Days  30

 Start of Day
 SYS011 Outstanding Tasks Alert. This alert sends an email with a list of open tasks from menu (Company Administration -> Tasks) to the "Assigned To" users. The email is also copied to addresses defined in the document template and in this process.

Document Template: Tasks Outstanding Listing Alert
 Start of Day
SYS012

Integration Alert for failed transactions. This alert sends an email with a list of failures from menu (Integration -> AP Invoice View, AR Adjustment View, AR Receipt View, AR Sales Order View, AR Transaction View, GL Journal View) to the email addresses configured in the rules. Recommended Frequency: Every Day

Process Rules
 Rule Code  Description  Value Caption  Default Value
 SYS012.ARTransaction  Email address for failed transactions from "Integration -> AR Transaction View"  email address  
 SYS012.Asset  Email address for failed transactions from Asset  email address  
 SYS012.Inventory  Email address for failed transactions from Inventory  email address  
 SYS012.Payroll  Email address for failed transactions from Payroll  email address  
 SYS012.POS  Email address for failed transactions from Point of Sale  email address  
  SYS012.Purchasing  Email address for failed transactions from Purchasing  email address  

 End of Day
SYS013 Email queue used to consolidate email alerts. When email alerts are configured to "Consolidate" notifications, this process will consolidate the messages and send out one email. Recommended Frequency: Start of Day  Start of Day